How to: Print an entire workbook.
Solution:
Open the workbook to print. Select 'Print' from the 'File' menu. Select the 'Entire Workbook' and the 'All' radio buttons and choose 'OK'.
1) Open the workbook to print.
2) Select the 'File' menu and select 'Print...'. (The Print dialog box appears.)
3) (Optional) Select the printer to which to print the workbook from the 'Name' drop-down list of the 'Printer' group.
4) Select the 'Entire Workbook' radio button in the 'Print What' group.
5) Select the 'All' radio button in the 'Page Range' group.
Specifying printing options
6) (Optional) Type the desired number in the 'Number of copies' box.
NOTE: The number of copies always defaults to '1'. Type a different number if necessary.
7) Click 'OK'.